package com.sino.operation.mapper;

import com.sino.operation.entity.SysCenter;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * 渠道表 Mapper 接口
 * </p>
 *
 * @author admin
 * @since 2021-10-07
 */
public interface SysCenterMapper extends BaseMapper<SysCenter> {
   @Select("select a.* from SYS_CENTER a left join SYS_ORG_CENTER b on a.CENTER_NO=b.CENTER_NO where b.ORG_ID=#{orgNo}")
    SysCenter selectCenterByOrgNo(@Param("orgNo") String orgNo);
   @Select("select * from SYS_CENTER")
   List<SysCenter> findCenter();
}
